﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Master Resources/XLMaster.Master"
    AutoEventWireup="true" CodeBehind="Dashboard.aspx.cs" Inherits="XclusiveClient.Dashboard" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Content" runat="server">
    <h1>
        <b>Dashboard</b></h1>
    Here's a quick view to your company's most essential data at this point of time
    <br />
    <br />
    <br />
    <h6>
        <u>Employee Details</u>
    </h6>
    <div style="text-align: center">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
            BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="employeeID"
            DataSourceID="SqlDataSourceAccount" ForeColor="Black" GridLines="Vertical">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="employeeID" HeaderText="employeeID" InsertVisible="False"
                    ReadOnly="True" SortExpression="employeeID" />
                <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
                <asp:BoundField DataField="company_name" HeaderText="company_name" SortExpression="company_name" />
            </Columns>
            <FooterStyle BackColor="#CCCC99" />
            <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
            <RowStyle BackColor="#F7F7DE" />
            <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
            <SortedAscendingCellStyle BackColor="#FBFBF2" />
            <SortedAscendingHeaderStyle BackColor="#848384" />
            <SortedDescendingCellStyle BackColor="#EAEAD3" />
            <SortedDescendingHeaderStyle BackColor="#575357" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSourceAccount" runat="server" ConnectionString="<%$ ConnectionStrings:XLConnStringAccount %>"
            SelectCommand="SELECT [employeeID], [name], [company_name] FROM [Employee] WHERE ([company_name] = @company_name)">
            <SelectParameters>
                <asp:SessionParameter Name="company_name" SessionField="company_name" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </div>
    <h6>
        <u>Order Details</u>
    </h6>
    <div style="text-align: center">
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4"
            DataKeyNames="orderID" DataSourceID="SqlDataSourceOrder" ForeColor="#333333"
            GridLines="None">
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
            <Columns>
                <asp:BoundField DataField="orderID" HeaderText="orderID" InsertVisible="False" ReadOnly="True"
                    SortExpression="orderID" />
                <asp:BoundField DataField="status" HeaderText="status" SortExpression="status" />
                <asp:BoundField DataField="ship_date" HeaderText="ship_date" SortExpression="ship_date" />
                <asp:BoundField DataField="ship_time" HeaderText="ship_time" SortExpression="ship_time" />
                <asp:BoundField DataField="ship_type" HeaderText="ship_type" SortExpression="ship_type" />
                <asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
                <asp:BoundField DataField="employeeID" HeaderText="employeeID" SortExpression="employeeID" />
                <asp:BoundField DataField="listID" HeaderText="listID" SortExpression="listID" />
            </Columns>
            <EditRowStyle BackColor="#999999" />
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#E9E7E2" />
            <SortedAscendingHeaderStyle BackColor="#506C8C" />
            <SortedDescendingCellStyle BackColor="#FFFDF8" />
            <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSourceOrder" runat="server" ConnectionString="<%$ ConnectionStrings:XLConnStringOrd %>"
            SelectCommand="SELECT * FROM [Order]"></asp:SqlDataSource>
    </div>
    <h6>
        <u>Inventory Item List Details</u>
    </h6>
    <div style="text-align: center">
        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataKeyNames="listID,productID"
            DataSourceID="SqlDataSourceList" CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="listID" HeaderText="listID" InsertVisible="False" ReadOnly="True"
                    SortExpression="listID" />
                <asp:BoundField DataField="productID" HeaderText="productID" ReadOnly="True" SortExpression="productID" />
                <asp:BoundField DataField="item_name" HeaderText="item_name" SortExpression="item_name" />
                <asp:BoundField DataField="qty" HeaderText="qty" SortExpression="qty" />
                <asp:BoundField DataField="price" HeaderText="price" SortExpression="price" />
            </Columns>
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F8FAFA" />
            <SortedAscendingHeaderStyle BackColor="#246B61" />
            <SortedDescendingCellStyle BackColor="#D4DFE1" />
            <SortedDescendingHeaderStyle BackColor="#15524A" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSourceList" runat="server" ConnectionString="<%$ ConnectionStrings:XLConnStringList %>"
            SelectCommand="SELECT * FROM [ItemList]"></asp:SqlDataSource>
    </div>
</asp:Content>
